SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_SearchBulletinEmploymentLecture]
    (
      @JOL_BulletinLecture_Title VARCHAR(50)
    )
AS 
    SELECT  JOL_BulletinLecture_No,
            JOL_BulletinLecture_Title,
            JOL_BulletinLecture_Time,
            JOL_BulletinLecture_Position,
            JOL_BulletinLecture_ClickNumber
    FROM    dbo.JOL_BulletinEmploymentLecture
    WHERE   JOL_BulletinLecture_Title LIKE '%' + @JOL_BulletinLecture_Title
            + '%'
    ORDER BY JOL_BulletinLecture_IsSetTop DESC,
            JOL_BulletinLecture_AddTime DESC,
            JOL_BulletinLecture_UpdateTime DESC

GO
